﻿<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="首页.aspx.cs" Inherits="WebApplication1.WebForm2" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
    <title></title>
    <link rel="stylesheet" type="text/css" href="style/Style_Gridview.css" /> 
</head>
<body>
    <form id="form1" runat="server">
        <div>
            <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="userName" DataSourceID="SqlDataSource1" 
                Class="gridview">
                <Columns>
                    <asp:BoundField DataField="userName" HeaderText="userName" ReadOnly="True" SortExpression="userName" />
                    <asp:BoundField DataField="password" HeaderText="password" SortExpression="password" />
                    <asp:BoundField DataField="identity_id" HeaderText="identity_id" SortExpression="identity_id" />
                </Columns>
            </asp:GridView>
            <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ticket_management_systemConnectionString %>" ProviderName="<%$ ConnectionStrings:ticket_management_systemConnectionString.ProviderName %>" SelectCommand="SELECT * FROM user"></asp:SqlDataSource>
        </div>
<<<<<<< HEAD
        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="userName" DataSourceID="SqlDataSource1" AllowPaging="True" AllowSorting="True" CellPadding="4" ForeColor="#333333" GridLines="None">
            <AlternatingRowStyle BackColor="White" />
            <Columns>
                <asp:CommandField ShowDeleteButton="True" ShowEditButton="True" ShowSelectButton="True" />
                <asp:BoundField DataField="userName" HeaderText="userName" ReadOnly="True" SortExpression="userName" />
                <asp:BoundField DataField="password" HeaderText="password" SortExpression="password" />
                <asp:BoundField DataField="identity_id" HeaderText="identity_id" SortExpression="identity_id" />
            </Columns>
            <EditRowStyle BackColor="#2461BF" />
            <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
            <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
            <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
            <RowStyle BackColor="#EFF3FB" />
            <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
            <SortedAscendingCellStyle BackColor="#F5F7FB" />
            <SortedAscendingHeaderStyle BackColor="#6D95E1" />
            <SortedDescendingCellStyle BackColor="#E9EBEF" />
            <SortedDescendingHeaderStyle BackColor="#4870BE" />
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ticket_management_systemConnectionString2 %>" DeleteCommand="delete from user where userName =?" InsertCommand="insert into user(userName, password, identity_id) values(?,?,?)" OldValuesParameterFormatString="original_{0}" ProviderName="<%$ ConnectionStrings:ticket_management_systemConnectionString2.ProviderName %>" SelectCommand="SELECT * FROM user" UpdateCommand="UPDATE user SET  userName = ? ,password = ? , identity_id =? FROM USER where userName = ?">
        </asp:SqlDataSource>
=======
>>>>>>> 31fd26428020fad38d183e1ebf71d6d88178d2f8
    </form>
</body>
</html>
